Add Fields to the Data Warehouse File for Orders and Invoices

Date Released: July 2019

Modules:Navigator FM, System Settings, CMS, Decor 24, and EDI

Description:

  • A new RADAR setting allows users to include POs in the data warehousing FM file for orders and invoices.

  • The setting, Decor24 ID, has been added to identify the user that entered the order.

  • When an order enters the system from Décor, EDI, or CMS an indicator is set to identify the origin.

New RADAR Global Setting

The setting Keep Purchase Orders in the Data Warehousing File has been added to the RADAR global settings.

The RADAR global settings are accessed by: menu option RDR 1> F8=Global Settings.

If the setting is set to Y, the PO data is sent to the Data warehousing FM file for orders and invoices.

PO Origin Identifier on the Invoice, Order and Pending Data Warehouse

Two new fields, Decor 24 ID and EDI Orgin, have been added to the end of the Invoice, Order and Pending Data Warehouse display in Navigator File Management.

The Decor24 ID identifies who entered the order in Decor 24.

The EDI Origin can be populated by one of the following character identifiers:

  • N - for orders entered normally
  • E - for EDI incoming orders
  • C - for CMS incoming orders
  • D - for Decor 24 incoming orders
The new fields were also added as Filters and to the Excel Spreadsheet that can be generated .